|
SAP IQ (also known as ''SAP Sybase IQ'' and ''Sybase IQ'') is a column-based, petabyte scale, relational database software system used for business intelligence, data warehousing, and data marts. Produced by Sybase Inc., now an SAP company, its primary function is to analyze large amounts of data in a low-cost, highly available environment. SAP IQ is often credited〔(C-Store: A column-oriented DBMS ), Stonebraker et al., Proceedings of the 31st VLDB Conference, Trondheim, Norway, 2005〕 with pioneering the commercialization of column-store technology. At the foundation of SAP IQ lies high-performance column store technology that allows for speed compression and ad-hoc analysis without additional tuning, as well as high scalability and cloud enablement. SAP IQ also provides application services enabling developers to build smarter apps. SAP IQ comes with in-database analytics, multilingual client APIs, federation and web enablement. It includes IQ database drives for web 2.0 programming environments and an extensibility framework for embedding analytics inside the database. The top layer comes with an ecosystem of partner solutions, tools, and apps that are embedded within SAP IQ through the application services layer. This includes Business Intelligence (BI) tools, data integration tools, database admin (DBA) tools, and packaged apps. Everything is encapsulated within a grid architecture. SAP IQ has an open interface approach towards its ecosystem. Many popular commercial and open source business intelligence and data integration tools are certified to work with SAP IQ. Moreover, now as part of SAP, SAP IQ is also integrated with SAP’s Business Intelligence portfolio of products to form an end-to-end business analytics software stack, and is an integral component of SAP's In-Memory Data Fabric Architecture and Data Management Platform. ==Awards & Recognitions== World’s Largest Data Warehouse Guinness World Record 12.1 PB – SAP IQ, SAP HANA, together with technology partners BMMsoft, HP, Intel, NetApp, and Red Hat generated a world record for the world’s largest data warehouse. ''“A team of engineers from SAP, BMMsoft, HP, Intel, NetApp, and Red Hat, built the data warehouse using SAP HANA and SAP IQ 16, with BMMsoft Federated EDMT running on HP DL580 servers using Intel® Xeon® E7-4870 processors under Red Hat Enterprise Linux 6 and NetApp FAS6290 and E5460 storage. The development and testing of the 12.1PB data warehouse was conducted by the team at the SAP/Intel Petascale lab in Santa Clara, Calif., and audited by InfoSizing, an independent Transaction Processing Council certified auditor.”'' There is a whitepaper about this record on (Building a 12 Petabyte Data Warehouse ) conducted by (Infosizing ) 抄文引用元・出典: フリー百科事典『 ウィキペディア（Wikipedia）』 ■ウィキペディアで「Sybase IQ」の詳細全文を読む スポンサード リンク
|